Best thing is
CREATE table phone_dedup AS
(SELECT a.phone_number,
a.status
FROM (SELECT rowid,
phone_number,
status
FROM phone_info b
WHERE b.rowid = (SELECT max(rowid)
FROM phone_info b
WHERE b.phone_number = a.phone_number
AND b.status = a.status)))
/