Yes, this should be possible using embedded data & query string parameter within your forwarding URL.
Within your survey flow, add an Embedded Data element. Then, add an element called "ID" (or whatever name you want). You will need to set this ID to whatever unique number/ID that you would like to give to a given participant. If you don't have a way to do this yet, the easiest thing to do would probably be to use the Qualtrics response ID, as that is guaranteed to be unique to each respondent. Setting up the embedded data element in your survey flow would look like this:
Next, you will need to set up a survey redirect link to the site that you would like your participants to land on. In your survey flow, add an "End of Survey" element at the end of your survey and click on "Customize". Within this menu, add your forwarding URL by selecting "Override Survey Options", "Redirect to a URL". At the end of your URL you input into this field, you will need to append "?ID=${e://Field/ResponseID}", which is a query string parameter that will forward the ID information to whatever site you're referring participants to. You'll just need to make sure that whatever site you're forwarding to has the ability to capture this information.
Alternatively, if you do end up going the ResponseID route, you can forgo the Embedded Data field and just have your end of survey redirect URL be the following:

That should be it! Let me know if you have any questions.

Many thanks for this, this seems to be what I am looking for. However, we are using a custom End of Survey message and I was wondering if its possible to reference an embedded data field within the end of survey message?

Sure thing. Instead of doing a redirect, you can add a hyperlink on your end of survey message that is the same thing that I specified above.
So, for example, something like:

Thank you for taking our survey! Please click on the link below to move onto the next site.

https://mywebsite.com?ID=${e://Field/ResponseID}

Many thanks for your help

Hi, I have a question related to yours. Is qualtrics recording the data of the respondents who DO CLICK the hyperlink?