Nigel Farage becoming Prime Minister is no longer “impossible,” former first minister Nicola Sturgeon has said.