How to change the serial number after sorting the Parts based on any LIG attribute?

Summary:
Hi Community!

We have a commerce process where we want to add parts at a random sequence, but after that we want to sort it on any random attribute from the LIG!

Example:
SN - Part Number
1 - 1111
2 - 3333
3 - 6666
4 - 5555
5 - 4444
6 - 2222

Now as per System when we sort this based on Part number we get:
SN - Part Number
1 - 1111
6 - 2222
2 - 3333
5 - 4444
4 - 5555
3 - 6666

But we want this to happen as
1 - 1111
2 - 2222
3 - 3333
4 - 4444
5 - 5555
6 - 6666

Can this happen? if yes, can you please guide on how to achieve this?

Content (please ensure you mask any confidential information):