Remove ScalarValue Ord / PartialOrd #7517

Is your feature request related to a problem or challenge?

The performance of sorting ScalarValue directly will be exceptionally poor, especially when compared to vectorised approaches operating on arrays or rows, and having separate mechanisms introduces opportunity for inconsistency.

Describe the solution you'd like

Remove PartialOrd and Ord from ScalarValue

Describe alternatives you've considered

No response

Additional context

#7353 #7352 both track using ArrayRef within ScalarValue which this would relate to