Lowest accreting protoplanetary discs consistent with X-ray photoevaporation driving their final dispersal