Frank Rogers has stepped down as chief executive of the Liverpool City Region Combined Authority