sql query for get next 3 and previous 3 records only

Question

hi developers ,

 

i want to get the next 3 records and next previous records.

 

there is two buttons is there on my web page . if user click the next button means it will get next nearby three records .

 

if the user click the previous button means it will get previous nearby three records .

 

thanking you

Paul.S