The man who has taken charge of UK research funding says Brexit presents scientists with an opportunity.