List View column order

I know if we select “in list view” they are shown in list view and the first column is the title field but how other columns are sorted?

The order is based on the position of the corresponding field in doctype

but that is not happening when I updated employee table, the status always comes second even though I added some upper fields in list view, so they should come first.

Yes thats correct. First name, second status (if present) and then the others according due to position in doctype