Mahika Gaur claims 3 for 15 to limit visitors but Lancashire comes unstuck before thrilling finale