DELETE FROM contacts
WHERE id IN (
  SELECT id FROM (
    SELECT id,
           ROW_NUMBER() OVER (PARTITION BY email ORDER BY id) AS rn
    FROM contacts
  ) ranked
  WHERE ranked.rn > 1
);