Some rigidity results for highest order local cohomology modules