CREATE TABLE post (id INTEGER, title TEXT);
INSERT INTO post VALUES (1, 'One'), (2, 'Two'), (3, 'Three'), (4, 'Four'), (5, 'Five');
-- page size 2, page 2 -> OFFSET = page_size * (page - 1)
SELECT id, title
FROM post
ORDER BY id
LIMIT 2 OFFSET 2;

LIMIT + OFFSET for page 2