This automation automatically connects every record to its neighbors, the ones above and below in a specific view. And it can be scheduled to run regularly. Every time it runs, it would update the linked records field with the latest sorting order.
If you click on the sample view below, you’ll see the table that’s used for the demo above.