DQL Query to return all the nodes in a chain in order

In my schema a Path node has a list of Nodes inside it and the Nodes are connected by a relation as primary path.
The query to get all the Nodes inside the Path gives me this graph

But the list is not in order.

{
  "data": {
    "path": [
      {
        "uid": "0x15f99",
        "name": "Test Test Path",
        "~Node.is_in_path": [
          {
            "uid": "0x15f9a",
            "name": "First Node"
          },
          {
            "uid": "0x15f9c",
            "name": "Second Node"
          },
          {
            "uid": "0x15f9d",
            "name": "In Between"
          }
        ]
      }
    ]
  },

How do I write a recursive query to find all the nodes that belong to a path and are connected in a chain.