Observation of many-body scarring in a Bose-Hubbard quantum simulator