[core] Fix Limit push down sort splits violates its general contract.

[core] Fix Limit push down sort splits violates its general contract. #12047