Funny thing - H2 in PostgreSQL compatibility mode requires that OFFSET should go strictly after LIMIT (like LIMIT 25 OFFSET 50). Otherwise it can't parse the query:
error in SQL statement "SELECT ..........   OFFSET 0  LIMIT[*] 25 "; 
expected "[, ::, *, /, %, +, -, ||, ~, !~, NOT,
LIKE, REGEXP, IS, IN, BETWEEN, AND, OR, ROW, ROWS"