If the U.K. public votes to leave the EU, Societe Generale's head of oil market research predict the price of would fall — but not for long.