Cambridge city council ordered the removal of a Prince Philip statue a decade after it was denied planning permission.