Keyset pagination
OFFSET reads and throws away every skipped row. Keyset pagination compares a row value with the last row you saw, so an index can jump straight there.
task
Page 2 of orders by (placed_at, order_id): the 10 rows after the row (2026-06-01 00:00 UTC, 100), without OFFSET. Return order_id and placed_at.