How to get next/previous record number in MySQL?

How to get next/previous record number in MySQL?

How to get previous record number in MySQL?
Data Table:
Name | SO No.
-----------------
Adrian | SO-00001
Adrian | SO-00002
Bianca | SO-00003
Carrie | SO-00004
Adrian | SO-00005
Bianca | SO-00006
Adrian | SO-00007
How can I get the result as below:
Name | SO No. | Previous SO
-------------------------------
Adrian | SO-00005 | SO-00002