@KrishK Offset is not supported, but there is an issue created for that: https://github.com/elastic/elasticsearch/issues/31549.
Regarding "pagination", in SQL world there is a similar approach using cursors. Behind the scene, for ES SQL, this is implemented using the scroll API. More about cursors here: https://www.elastic.co/guide/en/elasticsearch/reference/current/sql-pagination.html