Pagination Implementation

Implement cursor or offset pagination with stable ordering and sensible page size limits.

• software
• implement