How to send small batch request based on a large bundle set (MySQL, API)

Hello,

I am querying a dataset from MySQL and I need to update HubSpot with a batch update.
The batch update only allows to update 10 items at once.
My MySQL request contains 700 bundles.

Can you guide me on how to split the results in request with 10 items each?

I don´t have an array so I am lost on what to use to iterate and define the limits start and end for the MySQL query.

Thank you very much,
Ingo