Cursor pagination will offer better performance if the "order by" columns are indexed. To go next or previous page we can define as.

laravel-cursor-next-pagination.md

How to Get 'Next' Cursor for Cursor Paginate In Laravel

use Illuminate\Pagination\Cursor;

...
$nextCursor = $request->has('cursor') ? $request->get('cursor') : null;

$comments = Comment::cursorPaginate(20, ['*'], 'cursor', Cursor::fromEncoded($nextCursor));

// to get pagination metadata
$nextCursor = $comments->nextCursor()->encode();
$nextPageUrl = $comments->nextPageUrl();
$prevCursor = $comments->previousCursor()->encode();
$prevPageUrl = $comments->previousPageUrl();
$path = $comments->path();