Get Previus Next Record in Laravel

get_previus_next_record.php

<?php
// Get the current user that will be the origin of our operations
$currentUser = User::find(10);
 
// Get ID of a User whose autoincremented ID is less than the current user, but because some entries might have been deleted we need to get the max available ID of all entries whose ID is less than current user's
$previousUserID = User::where('id', '<', $currentUser->id)->max('id');
 
// Same for the next user's id as previous user's but in the other direction
$nextUserID = User::where('id', '>', $currentUser->id)->min('id');