GraphQL Pagination could be optimized

### Describe the problem you discovered

`Resolver.paginate_transactions` list all the addresses then fetch all the transaction then filter

### Describe the solution you'd like

we should list addresses and then filtering then fetching the transaction.

### Epic

_No response_

Start at the GraphQL Resolver.paginate_transactions entry point and trace how addresses and transactions are currently retrieved and filtered. Verify the pagination behavior and add or update coverage for the optimized retrieval order; done means filtering addresses before fetching their transactions without changing results.

Written by the indexing model from the issue text.