Scott Harris embraces an ‘exceptional opportunity’ to lead the Detroit Tigers