ORDER BY

Control the order of the query results.

SELECT Id, Name, Industry
FROM Account
ORDER BY Industry DESC NULLS FIRST, Id ASC NULLS FIRST

public inherited sharing class AccountSelector {

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

public with sharing class MyController {

    public static List<Account> getAccounts() {
        return AccountSelector.query
                .orderBy(Account.Industry).sortDesc()
                .orderBy(Account.Id)
                .toList();
    }
}