The Scottish Parliament has approved a plan for proof of vaccine to be required in order to gain entry nightclubs and many large events from 1 October.