Draft: refactor: implement pagination for all base entities (connection, credentials, messages, proofs and others) OP#404

Description

AFJ does not support pagination for connections but we need it for dashboard.

Related issues

https://plan.vereign.com/projects/vbd/work_packages/404

Testing

Checklist

• I have updated the documentation (if necessary)
• I have added unit tests for new functionality (if applicable)
• My code follows the style guidelines of this project
• I have tested this code on my local machine before submitting this MR

Reviewers

[Tag any reviewers that you want to review this merge request here.]

Additional Notes

[Add any additional notes or comments you have about this merge request.]