fast_paginate.sql

# For mysql
SET @id:=1
SELECT id, @num:=@num + 1 AS num
FROM (
  SELECT id FROM email_notifications ORDER BY created_at ASC
) AS t
HAVING MOD(num, 101) = 0;

# For postgresql
SELECT id FROM (
  SELECT id, (ROW_NUMBER() OVER(ORDER BY id DESC)) AS num FROM locations
) AS tn
WHERE num % 101 = 0;