The following query will allow you sort specific user pipeline based on another other user pipeline setting (It will only sort the identical environments exist in both users pipeline)
The input for the query is source and destination users and the project name
This is not official way to do it , but might assist you until formal solution will be in place.
Please run proper tests before using in production.
---------------------------------------------------------------------------------------------
update
-- set username you want to change the pipeline order, e.g John
user_pipeline_env_order upeo_s
inner join user_pipeline_report_pref uprp_s on upeo_s.pipeline_report_id = uprp_s.id and uprp_s.name = 'John'
inner join rc_version rcv_s on rcv_s.id = uprp_s.projectId and rcv_s.name = 'Project1'
-- set username to copy the pipeline order from , e,g superuser
inner join user_pipeline_env_order upeo_o on upeo_o.environment_id = upeo_s.environment_id
inner join user_pipeline_report_pref uprp_o
on upeo_o.pipeline_report_id = uprp_o.id and uprp_o.name = 'superuser'
inner join rc_version rcv_o
on rcv_o.id = uprp_o.projectId and rcv_o.name = 'Project1' and rcv_o.id = rcv_s.id
set upeo_s.priority = upeo_o.priority ;
-------------------------------------------------------------------------------------------
I tried it on MySQL base system
Thanks
Jacky