I have been trying to write a script to do that have no idea where to start and have been unable to do it if anyone was any idea on how to do it please share.
You would currently need to use Send HTTP Request to call the API that re-orders products in a collection.
https://shopify.dev/docs/api/admin-graphql/2024-07/mutations/collectionReorderProducts