A mysterious bright object spotted in Irish skies was likely the debris from an Elon Musk rocket, experts have said.