Keep The Newest Signup

signups:

WITH ranked AS (
  SELECT id, email,
         row_number() OVER (PARTITION BY email
                            ORDER BY created_at DESC, id DESC) AS rn
  FROM signups
)
SELECT id FROM ranked WHERE rn = 1 ORDER BY id;

Which ids come back?