When you synce your photos the Ipad will not sort them by name but in numeric descending order so your photos will not display in the correct order and there is no other way to sort them unless you own a Mac with Iphotos.... Please fix
I contacted an app maker and they are looking into expanding one of their existing photo apps to allow the iPad user to arrange the order.
I think this is mostly a Windows issue, because I read on another thread that iPhoto on macs allow for sequencing and this carries over to the iPad. Also, if the iPad sequencing is done with the date, then they'll have to determine the best method for dealing with this with that app.
If they do add the functionality to their app, I will post the info here.
No word from the app maker yet. They have an existing app called "Sort Shot" that will sort on multiple criterea. But the slide show is run on the app, not the ipad's photo app.
You can read about the app's capabilities in the app store to see if it would meet your requirements.