In this example we are going to transfer row 5 from the source to the destination. For this we use the following query with your connection:
SELECT * OFFSET 4 LIMIT 1
This will skip the first four rows and limits the query to only return one row after having skipped four. This makes it row 5.