With the default settings in your PayPal account, buyer will be shown a "complete purchase" button after the sale which they have to click to be redirected to the thank you page.
However, if you turn "auto return" and "payment data transfer" in your PayPal account > Profile > Website Payment Preferences.
To enable auto return, you need to enter a URL there. Since we will override it, you can simply enter your website URL there.
Please note, for direct credit card payments from buyer who don't have PayPal account, buyers will still be shown a "complete purchase" button.