如何根据SQL Server中的下一个记录字段进行排序？

I have a table that includes a key field, a following key, and up to two previous keys. How can I create a result that is sorted based on the next record being equal to the following key?I have a table that includes a key field, a fol