The San Francisco Police chief told CNN there was ‘no evidence’ to support the theory, despite it being trumpeted by Donald Trump Jr. and Elon Musk