Do not add redundant subquery ordering into plan #30979

Job	Run time
Check cargo fmt	40s
cargo check	5m 38s
build with wasm-pack	2m 30s
cargo test (macos)	9m 19s
cargo test (macos-aarch64)	9m 31s
Verify MSRV (Min Supported Rust Version)	6m 51s
Verify Vendored Code	54s
cargo test (win64)	43m 36s
cargo test datafusion-cli (amd64)	3m 55s
clippy	5m 26s
cargo test hash collisions (amd64)	14m 12s
check Cargo.toml formatting	2m 58s
cargo doc	4m 5s
cargo test (amd64)	9m 43s
cargo test doc (amd64)	14m 16s
cargo examples (amd64)	13m 17s
Run sqllogictest with Postgres runner	3m 43s
cargo test pyarrow (amd64)	2m 56s
verify benchmark results (amd64)	12m 10s
check configs.md is up-to-date	2m 55s
	2h 48m 35s

Provide feedback