Support different aggregate expression (outside SELECT list) in ORDER BY list

### Is your feature request related to a problem or challenge?

In aggregate query with order-by: order-by list should support expressions with `group by` columns, or aggregated `aggregate` columns, this syntax is widely supported (by DuckDB, postgres and likely many others)

For aggregate function in order by list case, now DataFusion only supports aggregate functions which have appeared in `SELECT` list

See example
```
-- Setup
DataFusion CLI v41.0.0
> create table t1 (groupby1 int, agg1 int, agg2 int);
```
```
-- This is supported
select groupby1, sum(agg1)
from t1
group by groupby1
order by groupby1, sum(agg1);

-- Not supported yet in DataFusion
select groupby1, sum(agg1)
from t1
group by groupby1
order by max(agg2);
```

### Describe the solution you'd like

_No response_

### Describe alternatives you've considered

_No response_

### Additional context

_No response_

Reproduce the two aggregate ORDER BY examples in DataFusion CLI v41.0.0, then trace how aggregate expressions in ORDER BY are handled and why only aggregates also present in SELECT are supported. Done means the query ordering by max(agg2) succeeds alongside the existing sum(agg1) case.

Written by the indexing model from the issue text.