Change ID's on mySQL database (using date)

Hi I want to change the ID's of a dB, check the image: [login to view URL] As you can see, from "image_id: 10" goes to image_id: 32 , so it's 'wrong', should be image_id: 11 1. Freelancer should change all the "image_id" to consecutive numbers, (1 , 2 , 3 , 4 .... until the end, more than 6000 ID's 2. Freelancer should take the DATE as a reference to assign the ID (older to newer), and NOT the ID itself (because a 2013 ID could have an ID like: 145225551235 and a 2014 ID an ID like: 5999) 3 I will provide an export of the dB so Freelancer could work with his own server. This job will end when freelancer sent me the fixed dB to my review. Saludos.