The problem I have:
HSPB case number is not numeric, if I sort by HSPB, it gives me 1,10,100
Step 1: Order by ObjectID field
Step 2: use sequential number function
ESRI doc
https://support.esri.com/en-us/knowledge-base/how-to-sort-and-create-a-sequentially-ordered-id-field-000018847