Feature: Allow ordering linked records in relationships (e.g., many-to-many)

Please confirm that the feature request does not already exist

• I confirm there is no existing issue for this feature request.

Use case

Follow-up to [#9916]

This feature request was originally submitted in #9916 but was closed as resolved due to a change #10543. However, that update does not address the core issue described here — the ability to define and persist the order of linked records in one-to-many and many-to-many relationships.

The original request remains valid and is pasted below without changes for clarity and continuity.

Use case In many scenarios, maintaining a specific order for linked records is essential. Examples include:

• Social Media Planning: When planning Instagram carousel posts, images need to follow a particular sequence to maintain narrative flow or visual appeal.
• Project Management: Tasks linked to a project should be ordered by priority or workflow.
• Playlists or Galleries: Songs or images in a playlist or gallery must appear in a defined order for a meaningful user experience.

Currently, NocoDB lacks the ability to define and persist the sequence of linked records, making it cumbersome to handle workflows where order is essential.

Suggested solution

The solution could involve two steps:

1. Adding an "Order" column: Since the intermediary table already exists for many-to-many relationships, it would be relatively straightforward to add a numeric Order column to store the sequence of linked records.
2. Drag-and-drop interface: To simplify user interactions, implement a drag-and-drop feature in the UI for managing the order of linked records. This order should be stored in the Order column and respected in views, exports, and automations. This approach mirrors a similar feature available in Airtable, which makes managing ordered linked records intuitive.

Additional context

Replicating similar functionality available in tools like Airtable would also make NocoDB more appealing for users migrating from other platforms.