Stephen Cotgreave eventually recovered the missing bullet eight days later at the same location where he first dropped the magazine