[SPARK-3349] [SQL] Output partitioning of limit should not be inherited from child

This resolves https://issues.apache.org/jira/browse/SPARK-3349
This probably not what we want, since the `limit` provided, I think the original implementation is better for performance reason.