SNOW-802269 Add ordering and size function for scala and java modules

[sfc-gh-gmahadevan]

Please answer these questions before submitting your pull requests. Thanks!

1. What GitHub issue is this PR addressing? Make sure that there is an accompanying issue to your PR.

   Fixes #NNNN

2. Fill out the following pre-review checklist:

   • [X] I am adding a new automated test(s) to verify correctness of my new code
   • [ ] I am adding new logging messages
   • [ ] I am adding a new telemetry message
   • [ ] I am adding new credentials
   • [ ] I am adding a new dependency

3. Please describe how your code solves the related issue.

   Adding missing ordering and size function available in python module but not in scala and java

Pre-review checklist

(For Snowflake employees)

• [x] This change has passed precommit
• [ ] I have reviewed code coverage report for my PR in (Sonarqube)

[sfc-gh-bli]

@sfc-gh-gmahadevan 1, do you have jira ticket for this PR? if yes, please add the JIRA number in the PR title, for example, SNOW-XXXXX xxxxx 2, do not push from your forked repo, you can create a branch in this repo and create PRs from this repo, otherwise, the merging gates don't work.