OFFSET

Efficient way to handle large results sets.

SELECT Id, Name
FROM Account
OFFSET 1000

public inherited sharing class AccountSelector {

    public static SOQL query {
        get {
            return SOQL.of(Account.SObjectType)
                .with(new List<SObjectField>{
                    Account.Id,
                    Account.Name
                });
        }
    }
}

public with sharing class MyController {

    public static List<Account> getAccountsWithOffset() {
        return AccountSelector.query
            .offset(1000)
            .toList();
    }
}