bug(coord): Adding ApplyLimitFunction support for cross-partition query routing

[vishramachandran]

Pull Request checklist

• [x] The commit(s) message(s) follows the contribution guidelines ?
• [x] Tests for the changes have been added (for bug fixes / features) ?
• [ ] Docs have been added / updated (for bug fixes / features) ?

Current behavior : (link exiting issues here : https://help.github.com/articles/basic-writing-and-formatting-syntax/#referencing-issues-and-pull-requests)

When query is routed to different partition for multi-ns queries, we see this type of error

invalid_query: Logical plan to query not supported for ApplyLimitFunction.....

This PR fixes the logical plan to query translation and also removes the default handler.