UK’s ‘science superpower’ dreams need cash, Royal Society chief warns