Why the pivot function has no option to manage the order?

Not alphabetical, just sorted left to right in ascending order.

How would you envision such an option?

It's not possible to maintain column order because column names before pivoting can come in a column in a different order in different groups. In one group it can be A to Z but in another group it can be Z to A.