[release-19.0] fix: order by subquery planning (#16049)

[release-19.0] fix: order by subquery planning (#16049) #21294