Use a different confirmation url on completed webform submission in email confirmation link
There is actually a Set the redirect URL field in the "confirmation" email page setting which i totally missed. See below: