Laravel - Pagination - Cursor Vs Offset Pagination

To illustrate the differences between offset pagination and cursor pagination, let's examine some example SQL queries. Both of the following queries will both display the "second page" of results for a users table ordered by id:

    # Offset Pagination...
    select * from users order by id asc limit 15 offset 15;
    # Cursor Pagination...
    select * from users where id > 15 order by id asc limit 15;

The cursor pagination query offers the following advantages over offset pagination:

However, cursor pagination has the following limitations: