Take the data from table and rotate the member on every 7th day or starting day of the week and continue for whole week continue till the date range.

Need help in rotation of data in Postgres.

There is a table called crew_details

There is a requirement to rotate the crew members for in weekly or on the every 7th day and continue for rest 6days the same order of for the given date range un till it reach end date . and the expected output should be like this below

Please can any one help me in in the rotation in postgres SQL