How to get next or previous record in T-SQL

SELECT

     id AS SP_ID

   , desc AS DESCRIPTION

   , part_no AS PART_NO

   , order AS ORDER_NO

   , updts AS UPDATE_DATE

 FROM  Table1 

 ORDER BY  id

        OFFSET 20 ROWS FETCH NEXT 10 ROWS ONLY