Footage shows off-duty FBI agent dancing in a bar and accidentally setting off gun while doing a backflip