[BUG] Limit with offset reach maxResultWindow should not fail the query

[LantaoJin]

What is the bug?
#3713 tried to prevent push down limit with offset reach maxResultWindow. But it depends the fallback mechanism to execute the query in v2 instead of execute in calcite. When the fallback disabled. The test https://github.com/opensearch-project/sql/blob/main/integ-test/src/yamlRestTest/resources/rest-api-spec/test/issues/3102.yml will fail in v3.

How can one reproduce the bug?
Add

setup:
  - do:
      query.settings:
        body:
          transient:
            plugins.calcite.enabled : true

in https://github.com/opensearch-project/sql/blob/main/integ-test/src/yamlRestTest/resources/rest-api-spec/test/issues/3102.yml

yaml test failed.

What is the expected behavior?
3102.yml should pass.