Is there performance loss in out of sequence inserted rows (MySQL InnoDB)
Tables are by nature unsorted, so you will not have any performance loss on that site, after inserting your data, but we doen't how your instances is smaller, we can't  tell the impact it will have.
Your index on that field will be sorted and so will find the wanted rows quite fast, at least faster as scanning the hole column.