Define Concrete Rule Order in Multistage Query Optimization

[shauryachats]

The current order of query optimization rules in the logical plan stage does not cover all the corner cases for multistage queries (an example is https://github.com/apache/pinot/pull/14198).

There is a need to define a concrete rule order after considering as many cases as possible, for the query optimizer to optimize most generic queries correctly.