How to correctly create a table and pagination?

Question

Database design

I ask for advice and opinions from you, with a problem that I encountered. I am writing a project in Laravel. How would you implement the following?
There are brands: name (for example: bmw, mercedes, Lamborghini) and models (for example: urus, m5, s-class)
When we go to /brands/bmw we see a list of bmw models. When we look at, for example, M5, then the next one is X6 (BMW model), how would you implement such pagination? What would you use? I now count by number using PHP functions. For some reason, I decided not to use parent_id in the table. Can you please tell me how to implement it?

Answer 1

brands
- id
- name
models
- id
- name
- brand_id
- sort
In the sort field, simply indicate the numerical order, what should come after what