A Brisbane man has been charged with attempted murder after allegedly stabbing another man in the neck with a syringe before being apprehended by off-duty police officers.