Council orders controversial £150k Prince Philip statue be torn down after row