Implement Pagination APIs for the backend

[vishnuchalla]

Description

With the new UI changes coming in as a part of revamp, implement pagination APIs for the backend as well. This will help us only query required data to render highlighted pages in the dashboard.

Acceptance Criteria

• Dashboard should take less page load time compared to what we have today.
• UI experience should be smooth while navigating between pages and initial load time should also be improved.

Relevant links: https://opensearch.org/docs/latest/search-plugins/searching-data/paginate/
cc: @chentex @MVarshini

[github-actions]

This issue is stale because it has been open 30 days with no activity. Remove stale label or comment or this will be closed in 5 days.

[github-actions]

This issue was closed because it has been stalled for 5 days with no activity.

[github-actions]

This issue is stale because it has been open 30 days with no activity. Remove stale label or comment or this will be closed in 5 days.

[github-actions]

This issue was closed because it has been stalled for 5 days with no activity.

[github-actions]

This issue is stale because it has been open 30 days with no activity. Remove stale label or comment or this will be closed in 5 days.

[github-actions]

This issue was closed because it has been stalled for 5 days with no activity.