On some SGDBs (at least Oracle Real Application Cluster), autogenerated ids are guaranted to be unique but not sequential. Therefor, sorting on such column can lead to wrong sorting.
At least one use case has been reported on the background task page.
There may be others. They should be looked up, reported in this ticket and fixed.