You have a text field it is is sorting as text into alphabetical order.
If you want numeric order, you need to sort on a field of type number.
My primary ID filed type is number; but the value itself contain letter & number.
So do you mean that because of this, it is sorting as text into alphabetical order? If I want it to sort in numeric order, I need to use all number for my primary ID field?
Better check again. What I see is typical of a field of type text. If it were of type number, it would sort by numerical value. You need to Open Manage | Database | Fields and check the defined field type.