Id's in Dynamics CRM have special ordering and when you do ORDER BY ASC or DESC based on the ID, the data might not order the way you expect until you get used to the way Dynamics CRM organizes itself.