Stony Brook enjoyed the thrill of a last-second victory in its season opener, but felt the bitterness of the other side in Friday’s loss to Hofstra.