Setting up a custom command in WinSCP to achieve this.
Preparation
VS Code is able to access the remote host via SSH. WinSCP is able to access the remote host via SFTP.
Setup a Custom Command in WinSCP
In WinSCP's 'Preference' dialogue, navigate to 'Command' panel showing command list and operations. Click on the 'Add...' button to call out the 'Add custom command' dialogue.
Fill in 'Description':
Fill in 'Custom command':
"C:\Program Files\Microsoft VS Code\Code.exe" --remote ssh-remote+!U@!@:!# !//!
Check 'Local command'. Check 'Use remote files'. Confirm both dialogues by clicking 'OK' buttons.
Usage
Right click on a remote SFTP folder to call out the context menu. Select in the menu 'File Custom Commands', 'VS Code' to have the remote folder opened in the VS Code. The custome command can also be accessed via a hotkey or the toolbar. (WinSCP V6)