You have done exactly what i did, but different reasons. I want to have a list of locations, with some first (i will add an * to illustrate top ones) , but then the rest sorted alphabetically.. e.g. where in uk are you? *London, *Manchester, *Birmingham, Aberdeen, Brighton, Chester, Dublin, Exeter, Farnborough etc.
so London, Manchester and Birmingham have a sort order of 1,2,3, and all others have a sort order of 10.
The issue is unless i enter them alphabetically in the table, i cannot sort the items with sort order of 10 alphabetically, they display in the order in which i enter them, which is a pain if i miss a location. I know i could manually add a sort order for each item, but far from ideal.