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

This resolves https://issues.apache.org/jira/browse/SPARK-3349
`SinglePartition` for `LIMIT` may cause performance issue for large number of records(in multiple partitions), do we really need to change this?