Deprecate the public `sort_order_for_type` public function

[etseidl]

Is your feature request related to a problem or challenge?

Following up on a comment from #9619.

SortOrder should be obtained from a ColumnOrder instance, rather than via a standalone function.

Describe the solution you'd like

Add a deprecation notice, and instead implement it in terms of a pub(crate) API.

Describe alternatives you've considered

No response

Additional context

No response