Issue with limit offset

[varun-lumi]

I need to fetch one row at a time passing the limit offset parameters. I used the below query:

MODEL::select('ID')
->orderBy('ID','DESC') ->limit(1)
->offset($offset)

Here I will increment the $offset value each time before running the query. But everytime I am getting the first record only.

How could I resolve this?

System details

• Operating System : Ubuntu
• PHP Version : 7.2
• Laravel Version : 5.2
• Laravel-OCI8 Version : 5.2