Hello, welcome to MongoDB Community
Try this:
db.collection.find({ "offers.photos._id": ObjectId("ID_HERE") });