What is offset in Apex and Using offset in soql
We can Use OFFSET keyword in SOQL to specify the starting row from the result returned by your query. This is useful in cases where we need to quickly jump to a particular subset of the total result returned by SOQL query. For example if there are 20 records then, if we specify offset as 10 in the query then it would return record 11 through 20.
OFFSET keyword can be used to implement pagination in visaulforce page tables.