Yes, VGA adapters are known to work with Raspberry Pi.
See
this doc at the elinux wiki for a list of known working adapters and other important info. They can be pretty tricky to set up depending on the adapter used.
You'll likely also want to research VGA specific settings for your /boot/config.txt