Fix Inconsistent Behavior of select_sequential_consistency in Count Queries and System Tables

Fix inconsistent behavior caused by select_sequential_consistency for optimized trivial count query and system tables. #16309 (Hao Chen).