The single order by in service.xml is the default one.
The persistence layer allows for passing in custom order by comparator instances, so you all need to do is add a method to your XxxLocalServiceImpl to expose a method that passes a different comparator to the XxxPersistenceImpl class.
